﻿<%@ Page Language="C#" AutoEventWireup="true" MasterPageFile="~/SiteMaster.master"
    CodeBehind="ViewSuggestedTasks.aspx.cs" Inherits="CivilleWebRole.ViewSuggestedTasks" %>

<asp:Content ID="HeaderContent" ContentPlaceHolderID="HeadContent" runat="Server">
    <style type="text/css">
        .style1
        {
            height: 14px;
        }
    </style>
</asp:Content>
<asp:Content ID="BodyContent" ContentPlaceHolderID="BodyContent" runat="Server">
    <table style="width: 100%;">
        <tr>
            <td class="style1">
                &nbsp;
                <asp:Label ID="BusinessSubTypeIDLbl" runat="server" Text="" Visible="false" />
                <asp:GridView ID="SuggestedTasksGridView" runat="server" AutoGenerateColumns="False"
                    DataSourceID="SuggestedTasksDataSource" AllowPaging="True" ShowFooter="True">
                    <Columns>
                        <asp:BoundField DataField="Title" HeaderText="Title" SortExpression="Title" />
                        <asp:BoundField DataField="Description" HeaderText="Description" SortExpression="Description" />
                        <asp:BoundField DataField="Points" HeaderText="Points" SortExpression="Points" />
                    </Columns>
                </asp:GridView>
                <asp:SqlDataSource ID="SuggestedTasksDataSource" runat="server" ConnectionString="<%$ ConnectionStrings:CivilleConnectionString %>"
                    
                    SelectCommand="SELECT [Title], [Description], [Points] FROM [SuggestedTask] WHERE ([BusinessSubTypeID] = @BusinessSubTypeID)">
                    <SelectParameters>
                        <asp:ControlParameter Name="BusinessSubTypeID" ControlID="BusinessSubTypeIDLbl" 
                            Type="Int32" PropertyName="Text" />
                    </SelectParameters>
                </asp:SqlDataSource>
            </td>
            <td class="style1">
                &nbsp;
            </td>
        </tr>
    </table>
</asp:Content>
